Main
Douglas MacDonald
I have a deep love and affinity for all things data and computing. My professional career has always been focused on helping others understand their data, streamline their current processes, and provide value to stakeholders.
Education
M.Phil Quantitative Methods
The University of Pennsylvania
Philadelphia, PA
2020 - 2017
M.S. Experimental Psychology
Saint Joseph’s University
Philadelphia, PA
2014 - 2012
- Thesis: Emotional Intelligence and Entitlement in the Workplace
- Member of Sigma Xi Scientific Research Society (prospective member can only apply if nominated by a current member)
B.S. Psychology
Saint Joseph’s University
Philadelphia, PA
2013 - 2009
- Graduated Cum Laude
- Dean’s List, Spring 2010 – Spring 2014
- Presidential Scholarship
Research Experience
Graduate Research Assistant
Saint Joseph’s University
Philadelphia, PA
2014 - 2013
- Reported to and worked one on one with the Chair of the department. Worked one on one with tenured professors in the Food Marketing Department
- Conducted independent data collection, coding of data, theory development, survey generation, data analysis, and management of large data sets (exceeding 4 million respondents)
- Teaching Assistant for several undergraduate level classes. Required to lecture and present new material
Assistant Consultant Support
Applied Psychological Techniques
Darien, CT
2012 - 2011
- Coded and analyzed data from clients. Literary searches and company profiling. Collaborated with and assisted professionals in the field of Industrial/Organizational Psychology. Worked first hand with Kathleen K. Lundquist, Ph.D, CEO of APTMetrics.
- Read 10-k reports for company profiles. Greatly improved efficiency in Microsoft Word, Excel, Adobe Acrobat Pro
Industry Experience
I have worked in a variety of roles in data/decision science, in both non-profit and for-profit sectors.
Director for Research and Analytics Development
Middle States Commission on Higher Education
Philadelphia, PA
Current - 2019
Senior Analytics Specialist
Middle States Commission on Higher Education
Philadelphia, PA
2019 - 2017
- Develop automated data pipelines (extract, transform, and load clean data) leveraging Federally available and proprietary data for use in reports in analyses.
- Create databases, develop algorithms and statistical models, and perform statistical analyses appropriate to the available data and reporting requirements. Develop dashboards, reports, charts, graphs, and tables displaying the outcomes of analyses for use by internal and external stakeholders.
- Use system reports and analyses to identify potentially problematic data, make corrections, and determine root cause.
Lead Decision Science Analyst
Communications Media Inc
Philadelphia, PA
2017 - 2016
- Directly reported to and collaborated with Wayne Obetz, PhD, VP of Investment Analytics and Decision Sciences, on various company and client initiatives. Conducted statistical analyses and modeling (accomplished within R, and KNIME an open source analytics platform), appliedcommon machine learning (i.e. Random-Forest) techniques to better understand behavioral characteristics of physicians (accomplished within R and KNIME)
- Conducted classification techniques (i.e., CART - Classification and Regression Trees, CHAID, k-means) to produce comprehensive profiles of physicians (accomplished within R and KNIME). Joined and appended new data sets and sources (Prescription information, Sales Rep activity, Sample Request data, etc.) to existing marketing target lists and third party syndicated research (accomplished within R and SPSS). Manipulated, transformed, prepared and staged complex data sets for statistical analyses (extracting key variables of interest, string manipulation, and applied business rules to better define sub-segments of target list) (accomplished within R).
- Managed large database structures (accomplished within R and SQL). Built comprehensive, client ready dashboards in Tableau (a data visualization and analysis tool). Effectively communicated results and implications to internal teams and external clients. Developed clear next steps from resulting analyses. Developed automated data manipulation and analysis scripts and functions (in R and SPSS). Liaison between IQRx and Product Development team to frame and build/QA databases, identify primary keys between data sources, and test possible resolutions to the department’s data warehousing needs and requirements
Application Developer / Data Analyst II
Development and Alulmni Relations, University of Pennsylvania
Philadelphia, PA
2017 - 2017
- Deliver system solutions for business needs involving Development and Alumni Relations software systems, data visualization and query tools (accomplished within R; an open source language and environment for statistical computing and graphics, SQL, Qlikview (data visualization and analysis tool), and Business Objects)
- Design, code, simulate, test, implement and maintain reporting solutions and associated middleware, interfaces and databases in highly complex solutions (accomplished within SQL, R, and Python). Develop predictive models, composed of various complex data sources, to identify those individuals likely to make a large contribution to the University, new donors, and donor retention (accomplished within R [data transformation, modeling] SQL [data cleansing, aggregation]). Develop high level summary reporting dashboards for internal and external use (accomplished within R (Markdown), and Qlikview)
- Analyze functional requirements and advise users in the planning, selection, implementation and use of solutions to address business requirements. Advise the planning, implementation, measurement, and analysis of success of giving campaigns. Ensure adherence to technical, quality assurance, data integrity, and security standards. Plan, organize, and manage projects and associated schedules and budgets.
Campaign Analyst
Communications Media Inc
Philadelphia, PA
2015 - 2014
- Lead analyst for all Business Intelligence efforts for IQRx (Analytics Department). Provided statistical analysis and modeling of doctor behavioral data and the resulting growth in script writing behavior (data was cleaned, manipulated, joined and analyzed within R). Built-out reporting dashboards (visualized in Tableau) and was responsible for organizing and scheduling all data.
- Responsible for the campaign management, reporting/insights, analysis and data-feed for 31 brands across five clients spanning different therapeutic markets and conditions. Company Trainer for Tableau and Tableau Doctor (internal Tableau troubleshooting team). Utilize behavioral data from our proprietary doctor list to plan, track, and validate our media efforts.
- Spear-headed statistical analyses for custom engaged user segments to validate marketing techniques. Developed and provided insights, analysis, and reporting for all assigned clients. Partnered with VP of Product Development to automate cost-actualization processes that were provided as a data-feed for external clients. As well as data-transformation for individual level data received from publishers (processes automated using Java).
Teaching Experience
I am passionate about education. I believe that no topic is too complex if the teacher is empathetic and willing to think about new methods of approaching task.
Javascript for Shiny Users
RStudio::conf 2020
N/A
2020
- Served as TA for two day workshop on how to leverage Javascript in Shiny applications
- Lectured on using R2D3 package to build interactive visualizations.
Data Visualization Best Practices
DataCamp
N/A
2019 - 2019
- Designed from bottom up course to teach best practices for scientific visualizations.
- Uses R and ggplot2.
- In top 10% on platform by popularity.
Improving your visualization in Python
DataCamp
N/A
2019 - 2019
- Designed from bottom up course to teach advanced methods for enhancing visualization.
- Uses python, matplotlib, and seaborn.
Advanced Statistical Learning and Inference
Vanderbilt Biostatistics Department
Nashville, TN
2018 - 2017
- TA and lectured
- Topics covered from penalized regression to boosted trees and neural networks
- Highest level course offered in department
Advanced Statistical Computing
Vanderbilt Biostatistics Department
Nashville, TN
2018 - 2018
- TA and lectured
- Covered modern statistical computing algorithms
- 4th year PhD level class
Statistical Computing in R
Vanderbilt Biostatistics Department
Nashville, TN
2017 - 2017
- TA and lectured
- Covered introduction to R language for statistics applications
- Graduate level class